import db from '../dbserver'
import Sequelize from 'sequelize'

const Jurisdiction = db.define('Jurisdiction', {
    id: {
        type: Sequelize.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
    },
    Jurisdiction_name: {
        type: Sequelize.STRING(255),
        allowNull: true
    },
    Jurisdiction_path: {
        type: Sequelize.STRING(255),
        allowNull: true
    },
    Jurisdiction_type: {
        type: Sequelize.STRING(255),
        allowNull: true
    },
    parent_id: {
        type: Sequelize.INTEGER(11),
        allowNull: true
    },
    type: {
        type: Sequelize.INTEGER(1),
        allowNull: true
    },
    order: {
        type: Sequelize.INTEGER(3),
        allowNull: true
    }
}, {
    timestamps: false,
    freezeTableName: true,
    tableName: 'Jurisdiction'
});

export default Jurisdiction
